NYC Crime Overview

Data Visualization Group K: Chen Wang, Meilin Yuan, Zhuohan Wang, Sifan (Carol) Liu

Research Topic

The crime situation deserves attention from the public because it can affect people’s safety directly. We are interested in comparing NYC crime statistics from the past and the present to reveal trends and important messages. In this project, we are going to explore as deeply as we can of the changes in the crime situation in NYC (Manhattan, Bronx, Queens, Brooklyn, Staten Island) over the past 10 years and the present. It’s an efficient way to reflect the changes in the level of safety in NYC as time goes on.



Data

Our analyses are based on four datasets downloaded from NYC Open Data and Kaggle. The datasets contain information including crime type, suspects and victims’ race, gender, age group, and detailed coordination of each criminal case in New York State from 1990 to 2021.



Overall Crime Trend in NYC in the Past

According to the information provided by the NYPD, the crime situations in the five boroughs of New York City show significant changes over the past ten years. Therefore, we looked at the overall crime rates and the crime growing rates in the past (before COVID) and present (post-COVID) in NYC, and determined the level of danger for each borough by adjusting its crime rate by its population and area.



The first plot is the changes in total crime cases from 2009 to 2018, ten years before COVID 19. Obviously, Staten Island has the lowest number of total crime cases, and it keeps lower than 10000 total crime cases in these ten years. However, the trend in Manhattan is not stable, and it even offers an uptrend as time goes by, so we predict Manhattan is the most unsafe borough in New York.







Based on the hypothesis from the first plot, we made a plot showing the growth change rate. The green color bar means the growth rate this year compared to the previous year is going down, and the red bar represents the growth rate is going up compared to the previous year. Most years show a downtrend compared with last year, especially in 2020. This situation may be caused by people usually staying at home due to the outbreak of COVID, so the crime situation improved automatically. The improvement of COVID in 2021 dramatically increases the growth rate of 2021 proves this argument.







The third plot is a bump chart that ranks each county’s danger level because we think adjusting the rank by different measurements will make the conclusion more accurate. This plot proves the argument in the first plot. Staten Island is the safest county in the five boroughs of NYC because it always has the lowest rank of danger level regardless of adjustment type. However, Manhattan is the most dangerous borough in NYC from the bump chart because it keeps having the top rank of danger level in multiple measure methods.

In conclusion, Manhattan is the most dangerous and Staten Island is the safest borough in NYC. Also, the outbreak of COVID-19 “solved” the crime situation temporarily.



Different Crime Types in the Five Boroughs in NYC

According to the dataset from Kaggle, there are several types of major crimes in the five boroughs in New York City, such as murder, rape, robbery and aggravated assault. People may be curious to find out which borough has a higher crime rate and which type of crime occurs the most in NYC? To achieve this, we conducted graphs of each type of crime for the five boroughs in NYC from 2009-2018. By doing so, people are able to see clearly the crime situation in ten years in each borough.



The fourth plot is a New York City map which shows us percent of violent crimes in each borough in year 2018. Violent crimes include murder, rape, aggravated assault. From the map, we can see that Brooklyn borough has the biggest circle, which means it has the highest number of violent crimes. On the contrary, Staten Island borough has the smallest circle, which means it has the least number of violent crimes. In addition, Brooklyn and Bronx borough have the most number of murder. Therefore, obviously Brooklyn and Bronx are more dangerous than the other three boroughs.







After looking at total violent crimes, we made the fifth plot, which is a group bar chart showing us the total number of murders in 5 boroughs in New York City from 2009-2018. Since murder is one of cime that people most concerned about. From these ten years data, we can clearly see that Brooklyn has the most number of murders in every year. Fortunately, the total number of murders in Brooklyn is in a downward trend from 2009-2018. Manhattan and Staten Island have relatively less number of murder cases from 2009-2018. Therefore, they are safer than Brooklyn, Bronx and Queens.







The sixth plot is a group bar chart which shows us the total number of rapes in 5 boroughs in New York City from 2009-2018. The reason why we made this plot is we were shocked by the data. The total number of rapes in the New York City suddenly surged in year 2015. The number of rapes in 2015 has twice as many as in 2014 and it presents a upward trend from 2015-2018. The number of rapes in all five boroughs are increasing every year from 2009-2018. Although Staten Island has the leaset number of rapes, the other four boroughs all have lots of cases of rapes. Therefore, government should definitely pay more attention to the increasing number of rapes in NYC.







Finally, robbery is also the most common crime, so we made the plot which is a group bar chart showing the total number of robberies in 5 boroughs in New York City from 2009-2018. From the plot we can clearly see that robbery is the most frequent type of crime. Nearly 20,000 robberies occur every year in 5 boroughs in New York City. The good new is the total number of robberies is declining from 2012 to 2018. Brooklyn still has the most number of robberies among all 5 boroughs. The Bronx, Queens and Manhattan have similar amounts of robberies in each year from 2009 to 2018.

Overall, from these ten years of data, we concluded that Brooklyn and Bronx were relatively more dangerous than Queens, Manhattan and Staten Island. Brooklyn has the highest number of all crime types among 5 boroughs. Therefore, the government should pay more attention to the safety problem in Brooklyn.



Victim’s Ethnic Group and Harassment Situation by Genders

According to statistics released by the NYPD, the majority of crimes committed in the New York City area are in minority neighborhoods, and they are high! Statistics for shootings, murders, and felonies are over 80% in each category. These crimes are typically committed by minorities towards other minorities. Thus we decided to look into the victim’s ethnicity and how each borough’s situation differs.



The bar graph displays the victim’s race in the Bronx borough between 2009 and 2018. From this bar graph, we can see that White Hispanics and Black are the top two ethnic groups in victims, far more than any other race.







The bar graph displays the victim’s race in the Brooklyn borough between 2009-2018. From the bar graph, we can see that victims are far more likely to be black than other races. Brooklyn also has the highest number of crimes compared to other boroughs.







The bar graph displays the victim’s race in the Manhattan borough between 2009 and 2018. From the bar graph, we can see that Manhattan is behaving quite differently from Bronx and Brooklyn. In Manhattan, victims are more likely to be white, black, or white Hispanic compared to other races.







The bar graph displays the victim’s races in the Queens borough between 2009-2018. From the bar graph, we can see that Queens shares a similar pattern with Manhattan where victims are more likely to be black, white, or white Hispanic.







The bar graph displays the victim’s race in the Staten Island borough between 2009-2018. From the bar graph, we can see that there are a lot fewer crimes in Staten Island than in any other borough. Victims living on Staten Island are more likely to be white than other races.

Overall, we can conclude from Figure 8 that Brooklyn and the Bronx show similar patterns where minorities are the main subject of victimization. Brooklyn also has the highest number of crimes among the 5 boroughs. Manhattan and Queens share similar patterns where the race distribution is more aligned with the race population distribution. Staten Island, being the safest borough of all, has far less crime than any other borough with victim’s race distribution similar to population race distribution, similar to Queens and Manhattan.







To look at Victim’s ethnic groups more broadly, we created a pie chart showing the racial comparison of victims for the past 10 year in total (2009-2018). It shows that Black takes up 35.9% of the victim’s population, followed by White at 25.5% and White Hispanics at 24%. This aligned with previous results (victim race by borough bar graphs).







This graph shows a similar output to the previous one but in a time series, so it will be easier to see how the distribution varied in each year.

A video exposing 10 hours of sexual harassment in New York has had nearly 40m hits in 2014. It even has its own Wikipedia page called “10 Hours of Walking in NYC as a Woman.” In the video, Shoshana Roberts, a 24-year-old actor spent a day walking the streets of New York, dressed in jeans and a black T-shirt, while a hidden camera recorded the extraordinary number of catcalls she received, including rape and death threats. Harassment has been a serious issue in New York and thus we want to look into harassment cases by gender and by area.



The above is a leaflet Harassment map by victim’s sex, with the number of harassment that happened in each area. Feel free to zoom in and explore the plot, the right corner allows you to choose the gender displayed on the map.



Moving into 2021, the Post-Pandemic Year

There are changes in crime frequencies and types during the post-pandemic era in comparison to the pre-pandemic years before the end of 2019. Many people feel that crime rates in NYC have been rising, while theft fraud and fraud-related offenses are noticeably more frequent than before. Therefore, we also analyzed the latest NYC crime statistics in 2021 to see whether or not what people believed actually happened.



First, we used heat maps to illustrate the overall crime densities of NYC for 2019 and 2021. For both pre-pandemic (2019) and post-pandemic (2021), two of the most crime-concentrated spots in NYC remain the same: Herald Square and Harlem. What’s different is that compared to 2019, in 2021, crime densities slightly increased in west Queens and lower Manhattan and slightly decreased in Bronx and Brooklyn. In conclusion, there seem to be fewer crimes in 2021 than in 2019.






We then looked into whether or not changes in crime types contributed to the decline in crimes. The flipped bar charts show the 20 most common types of crimes (ranked by occurrence) in NYC for 2019 and 2021. For both pre-pandemic (2019) and post-pandemic (2021), the three most common crimes remain the same: “petit larceny”, “harassment”, and “assault-related offenses”. Yet, in 2021, frequencies for all crimes shown on the chart were lower. This agrees with the message from the heat maps that there was a drop in overall crime counts in NYC in 2021 compared to 2019. There are also noticeable changes in rankings of crimes: compared to 2019, in 2021, “dangerous drugs”, “offenses against public admini”, “dangerous weapons”, “intoxicated & impaired driving”, and “criminal trespass” went down in rank, while “robbery”, “burglary”, “vehicle and traffic laws”, “grand larceny of motor vehicle”, “theft-fraud”, and “offenses involving fraud” went up in rank.





Given the changes in crime types, we would like to use our analysis from the latest data to update people on times of day with the highest crime rates in NYC. The bar graph is an overview of NYC’s crime frequencies at different times of day in 2021, where parts of the day are defined as follows: early morning: 00:00-5:59, morning: 6:00-11:59, afternoon: 12:00-17:59, night: 18:00-23:59. Contrary to the popular belief that most crimes take place at night, most crimes took place in the afternoon in NYC in 2021.

In conclusion, contrary to people’s belief that crime rates in NYC are higher post-pandemic than pre-pandemic, according to our data, the overall crime rates in 2021 were lower than that in 2019. However, in terms of changes in crime types in NYC, people’s feelings are right: theft and fraud-related offenses were indeed more frequent in 2021.



Conclusion

We can draw various conclusions from our analyses for this project.

First, Manhattan is the most dangerous borough and Staten Island is the safest borough in New York City from multiple perspectives, including but not limited to the trend of the number of crimes cases, crime density, and danger level adjusted by different measures. Police departments should increase security patrols in Manhattan in the future.

Second, the outbreak of COVID-19 and the subsequent lockdowns reduced crime in New York City significantly; However, the decreasing impact of COVID-19 has been worsening the crime situation in NYC again. Police departments should increase security patrols in areas with higher populations.

Third, females’ risk of being victimized by crime is much higher than males in New York City, so females’ safety remains a serious issue.

Overall, the crime situation in New York City deserves great attention from both police departments and the public if it doesn’t get improved efficiently as time goes on.

For all the code, data used, process book, and related materials please visit our repository for more information.